UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'suBJBJZ1Ce2elciONHAV19kkOGqRKG7g7dE4bf/E2Yo=' 
WHERE 
  key_id = '95bf8e5f2ec746b174379c95059c03ed6610cebf8e1a7b354ba4ecf9ba272d44' 
  AND (
    token = 'suBJBJZ1Ce2elciONHAV19kkOGqRKG7g7dE4bf/E2Yo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034