UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SzjxPWxQRnfZYmZUpbA41x5A1Rv9yUwTTjQi9/7KCE0='
WHERE
key_id = '3a0804246b239187c612547bbb8763618a90bbcd3144e95e2d1f156da4027cc7'
AND (
token = 'SzjxPWxQRnfZYmZUpbA41x5A1Rv9yUwTTjQi9/7KCE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)