UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKq01TZ8MXFAL/l1z71bK5mPHWeEUm1f1vp9E4xyrD4='
WHERE
key_id = '2e01690c5c2e758c62ef683cb3fec0edf647e56c188a3279a9d2984f9481bc99'
AND (
token = 'qKq01TZ8MXFAL/l1z71bK5mPHWeEUm1f1vp9E4xyrD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)