UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MQCpywXMWrbFSuT6I7NVFv3VAdrSlkUN39qCav1j+M='
WHERE
key_id = 'c3b7509f36e5937f1420aef012c7e1947caec8950d5ffd4391ae39368d08b66a'
AND (
token = '1MQCpywXMWrbFSuT6I7NVFv3VAdrSlkUN39qCav1j+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)