UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F6rtXel8FSyYOUvGSZLmJ3RkNn2lVH2rBqGnoddw8Jk='
WHERE
key_id = 'd99086bdf25417e197768b22fed9f0feda92ccd049e5a3cd5049245aa5a3e3a7'
AND (
token = 'F6rtXel8FSyYOUvGSZLmJ3RkNn2lVH2rBqGnoddw8Jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)