UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I6BkL+UF+Pt9Vz4g/WxX4Hm88UT1VacwQGlPiq34gaA=' 
WHERE 
  key_id = 'e66b98f54b1f99c5ae293fc2e0e77a8fc4343e500ae12607fea38734d6ab436f' 
  AND (
    token = 'I6BkL+UF+Pt9Vz4g/WxX4Hm88UT1VacwQGlPiq34gaA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034