UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htilUyeIeVBu1QNrYVEaC1amO+LPOCzaxEXwPy7jqvw='
WHERE
key_id = '146243e69994dd395b7b2982b7d234a2ba8b502eb79d61fb7fea0325a437f781'
AND (
token = 'htilUyeIeVBu1QNrYVEaC1amO+LPOCzaxEXwPy7jqvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)