UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VQCfWXghjn+KRGya9bsQ0etaoszshmVI6Zc4nFiuRME='
WHERE
key_id = 'b8d41da365dd12e89d7174c011e9888e882f5f971a041f67a35646b2a2eab4e0'
AND (
token = 'VQCfWXghjn+KRGya9bsQ0etaoszshmVI6Zc4nFiuRME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)