UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WzfYlP10OiUGGzNtITI1M2TWD5F6ezKfSS6aIrGJFsU='
WHERE
key_id = '92008fc219a0b96beae4ef6846b4f3e2c1f1ead34cfa42cf97b5703ef6263b5e'
AND (
token = 'WzfYlP10OiUGGzNtITI1M2TWD5F6ezKfSS6aIrGJFsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)