UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27N7BaE40uFZOsM6bY9Sk9QzZnFP7YYses1YHim4pxw='
WHERE
key_id = '071f0be90b8192255b7e1a3bab8e6a937098d3b0109b05d96a64c519a18bb7f6'
AND (
token = '27N7BaE40uFZOsM6bY9Sk9QzZnFP7YYses1YHim4pxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)