UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7FNE3ukrrfOyGfTLYOUZgWw4/RAZ+QesPaWgdeR5Hw='
WHERE
key_id = 'fd3a4c867fdfff8eb1df9833bb9d1c01e44047e28a6e61b6ab3b51cff2b17906'
AND (
token = 'z7FNE3ukrrfOyGfTLYOUZgWw4/RAZ+QesPaWgdeR5Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)