UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9QmwN9tfCy4MeRSMmxzHzYcMvCojlwOYSsiOIdZ0rn8='
WHERE
key_id = '3c38e265aae0f78d15b6dde4bb0b3ec0255bb3a7badca1acdd29460291464152'
AND (
token = '9QmwN9tfCy4MeRSMmxzHzYcMvCojlwOYSsiOIdZ0rn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)