UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HL1O4Jg/n4VpKxzbdISUhC9OPaZB+B/z5m4MedlaGVU='
WHERE
key_id = 'af839c6558ac2266357b5c967bd558e63fd4e535eb9b015f718b220c1e92787c'
AND (
token = 'HL1O4Jg/n4VpKxzbdISUhC9OPaZB+B/z5m4MedlaGVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)