UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGh5XepqoG0j3Ew4YO5sNS+aloXZuX3oaaK74H76aT0='
WHERE
key_id = '4d838a661ca0e598c45d9e4aed66f97a65a18d360d73e03a5e485eb5da09896a'
AND (
token = 'vGh5XepqoG0j3Ew4YO5sNS+aloXZuX3oaaK74H76aT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)