UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C+dJ3ONalKjFgm31w/Rr8LMU721DXNe0H/XE+zAYZzs=' 
WHERE 
  key_id = '0c3be5f68cb5e8601bdfa54ca03dca91021a018496205bf19495d925814361cc' 
  AND (
    token = 'C+dJ3ONalKjFgm31w/Rr8LMU721DXNe0H/XE+zAYZzs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034