UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cfOnZTws6oB9CEWIGejZS9UOZ/9zc+UHa3XA5PXrJk0='
WHERE
key_id = 'c9a004fb30482b1ff81c926ba6677c054f1a3d590ef017919d851b6fb70bc986'
AND (
token = 'cfOnZTws6oB9CEWIGejZS9UOZ/9zc+UHa3XA5PXrJk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)