UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/Yov23hlzk7lbrL9LneU6tjrVzW+EtdFSz2D+xlMHA='
WHERE
key_id = '24db1264293215d16a1d55586712000df99e47e363311b36cb09325ade296d7e'
AND (
token = 'U/Yov23hlzk7lbrL9LneU6tjrVzW+EtdFSz2D+xlMHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)