UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOp1DSCJ+HDnmeX5R2ySYpIdMSHfC1+TgzI789JHPUo='
WHERE
key_id = '4fb6c26cf181ba4fe44307a65286f5335428462744f24b6307070bd7dc0bb2e6'
AND (
token = 'QOp1DSCJ+HDnmeX5R2ySYpIdMSHfC1+TgzI789JHPUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)