UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R7QE0ACLxj9gHQ00//lmTew/lnIyXfsdbAvTqEbSXxY='
WHERE
key_id = 'd52c512766143793e8e32e4e73b841361353465ea3d8aef275a79b7a2e04aec7'
AND (
token = 'R7QE0ACLxj9gHQ00//lmTew/lnIyXfsdbAvTqEbSXxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)