UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01BYa+503XgvzrqYZhilssqVvY35bX7u74Xi0t1kNM8='
WHERE
key_id = '4647531e1b6a152c14f0e5cdac10840a8c08f6b5d37e8afb2c0997a57edadd87'
AND (
token = '01BYa+503XgvzrqYZhilssqVvY35bX7u74Xi0t1kNM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)