UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgjQjbs/JFxFkdGVhsz1FDHDA8vWMZcfLohP7rNgEGo='
WHERE
key_id = 'e06de24467de0d5f01d022022cd93d425e4529ea6030c5bace7d9fe0374a80a0'
AND (
token = 'xgjQjbs/JFxFkdGVhsz1FDHDA8vWMZcfLohP7rNgEGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)