UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ki2in2cqHuXJwojU4uiQMh9arX3r+8X4/clBc6tZkCU='
WHERE
key_id = '994246a1b74a5176720b0dae0fb03de63ef01c6795e89385680ec1b828716a27'
AND (
token = 'ki2in2cqHuXJwojU4uiQMh9arX3r+8X4/clBc6tZkCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)