UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OestpAHwDGWKCLqlsUn/KnpgCqhjLs25B0o7m9X3nn8='
WHERE
key_id = '309e11ba90f3074a56ddd91a08ebe28a23d7af8193894a5415c605fa55fe6c2e'
AND (
token = 'OestpAHwDGWKCLqlsUn/KnpgCqhjLs25B0o7m9X3nn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)