UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYeexHGD565kRXYfgwGYHU8bukKFpTxXPWWviv4HmoA='
WHERE
key_id = '3e0705db41f86f7b2129caeb64a15f538b269035342d0e7aebb1754da18e2dba'
AND (
token = 'xYeexHGD565kRXYfgwGYHU8bukKFpTxXPWWviv4HmoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)