UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WCvshlV3EdN+tN20GppDItE+DcaaQJlLO/1qUy2PNKU=' 
WHERE 
  key_id = '94837d3dacd5018af75ae2d40a79b60a8f5636a83ce8bb6980fc70ed118f8707' 
  AND (
    token = 'WCvshlV3EdN+tN20GppDItE+DcaaQJlLO/1qUy2PNKU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034