UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5TrOpyiAb7QVk6cijqoA+QAiA+v2leZURxNKyM/h3+c='
WHERE
key_id = '1efc86c4629ec5276eec7061b5131f23778ddb6552e071621fbf453e0d8e3411'
AND (
token = '5TrOpyiAb7QVk6cijqoA+QAiA+v2leZURxNKyM/h3+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)