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