UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Lof9BJ5Wcj3f2XvClJuXu3mwtSuzn4AMViK0XqSGmo='
WHERE
key_id = '8ac38f7d1f68371b2b795677e6334a45df07abc34e14da18ec04430da73ed439'
AND (
token = '4Lof9BJ5Wcj3f2XvClJuXu3mwtSuzn4AMViK0XqSGmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)