UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vtl3K0gOVtlfcM7xD3B62PWLK4Y5nY8EVexPvAXMqEQ='
WHERE
key_id = 'c9cbc5a972432ee657844d5b628ec5a98f594d13053c14a97f27894642d73975'
AND (
token = 'Vtl3K0gOVtlfcM7xD3B62PWLK4Y5nY8EVexPvAXMqEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)