UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgYe1PPkpZU1tp5RaTruxsu94hQdsvnZq/yAocL4oMY='
WHERE
key_id = '1d136c863673fc0835da836e833201692e518019a8009e96bee391e778cf2230'
AND (
token = 'YgYe1PPkpZU1tp5RaTruxsu94hQdsvnZq/yAocL4oMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)