UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'upV4TqNWW7Qcc6LLL8ZUYuReFYfmwJYyWipBNEC9WoM='
WHERE
key_id = '601c4bf7fb883706f1990a232743c937b3db7f007091e9221d06db9f361c7090'
AND (
token = 'upV4TqNWW7Qcc6LLL8ZUYuReFYfmwJYyWipBNEC9WoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)