UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBdi7gO1kqr3ljI87ZeffcCEh6VI4Uo5j9oQCZ+B0JU='
WHERE
key_id = 'ac7e4554528a22e557639a9ec2380dc4e4db72ef2a09be4429956e32023eb43a'
AND (
token = 'ZBdi7gO1kqr3ljI87ZeffcCEh6VI4Uo5j9oQCZ+B0JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)