UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0Sob8Rva8+qwblzZ7xkqI8UGfwf0tS01Tg3PtENJqoc=' 
WHERE 
  key_id = '3dcd1ba5d56b4016c93f2243c4e594d7b362a9bc4d299b363735b97cac07a8ba' 
  AND (
    token = '0Sob8Rva8+qwblzZ7xkqI8UGfwf0tS01Tg3PtENJqoc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027