UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Iyvr8sBHfbqXBsTfz9DeJ6o9/sY5bjqSUVBl8bcehg='
WHERE
key_id = '8ce2918968c45e389f7508126b9a571b4bbde9f4d3c70921a6dcaa90fdb8cd63'
AND (
token = '8Iyvr8sBHfbqXBsTfz9DeJ6o9/sY5bjqSUVBl8bcehg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)